﻿CREATE TABLE [dbo].[CustomerDevice]
(
	[Id] INT NOT NULL IDENTITY, 
    [OpenId] NVARCHAR(200) NULL, 
    [DeviceId] NVARCHAR(200) NULL, 
    [AbleDeivceId] NVARCHAR(200) NULL, 
    [CreateTime] DATETIME NULL, 
    [LastTime] DATETIME NULL, 
    [DeviceName] NVARCHAR(200) NULL, 
    [PhoneNumber]  NVARCHAR (50)  NULL,
    [Address]      NVARCHAR (300) NULL
    CONSTRAINT [PK_CustomerDevice] PRIMARY KEY ([Id]), 
    [BindState] INT NULL 
)
